<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %><%--
  Created by IntelliJ IDEA.
  User: cc
  Date: 2020/11/27
  Time: 10:17
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <meta charset="utf-8">
    <title>中华文献查询系统 | www.HWEN.com </title>

    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-capable" content="yes">

    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="css/bootstrap-responsive.min.css" rel="stylesheet">

    <link href="http://libs.useso.com/css?family=Open+Sans:400italic,600italic,400,600" rel="stylesheet">
    <link href="css/font-awesome.css" rel="stylesheet">

    <link href="css/style.css" rel="stylesheet">

    <link href="css/pages/reports.css" rel="stylesheet">


    <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>


</head>

<body>

<div class="navbar navbar-fixed-top">

    <div class="navbar-inner">

        <div class="container">

            <p><a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
            </a>

                <a class="brand" href="index.html">
                    中华文献查询</a></p>
            <p>www.HWEN.com

            </p>
            <div class="nav-collapse">
                <ul class="nav pull-right">
                    <li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                            <i class="icon-cog"></i>
                            设置
                            <b class="caret"></b>
                        </a>

                        <ul class="dropdown-menu">
                            <li><a href="javascript:;">返回旧版</a></li>
                            <li><a href="javascript:;">APP下载</a></li>
                        </ul>
                    </li>

                    <li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                            <i class="icon-user"></i>
                            用户信息
                            <b class="caret"></b>
                        </a>

                        <ul class="dropdown-menu">
                            <li><a href="javascript:;">修改信息</a></li>
                            <li><a href="javascript:;">退出登录</a></li>
                        </ul>
                    </li>
                </ul>

                <form class="navbar-search pull-right">

                    <%
                        Class.forName("com.mysql.jdbc.Driver");

                        String url="jdbc:mysql://localhost:3306/book";
                        Connection connection=DriverManager.getConnection(url,"root","root");

                        String sql ="select * from wenxian where username = ? and lianjie = ?";
                        // String sql="delete from user where id=3";
                        //String sql = "update user set name=? where age=?";
                        //String sql="insert into user(username,password,gender,age)values(?,?,?,?)";
                        PreparedStatement ps =connection.prepareStatement(sql);

                        ps.setString(1,request.getParameter("username"));
                        ps.setString(2,request.getParameter("lianjie"));


                        ResultSet rs=ps.executeQuery();

                        while (rs.next()){
                            out.print(rs.getString("username")+"-"+rs.getString(3)+"<br>");
                        }

                    %>

                    <input type="text" class="search-query" placeholder="Search">
                </form>

            </div><!--/.nav-collapse -->

        </div> <!-- /container -->

    </div> <!-- /navbar-inner -->

</div> <!-- /navbar -->





<div class="subnavbar">

    <div class="subnavbar-inner">

        <div class="container">

            <ul class="mainnav">

                <li>
                    <a href="index.jsp">
                        <i class="icon-dashboard"></i>
                        <span>版本</span>
                    </a>
                </li>



                <li class="active">
                    <a href="repost.jsp">
                        <i class="icon-list-alt"></i>
                        <span>首页</span>
                    </a>
                </li>

                <li>
                    <a href="">
                        <i class="icon-facetime-video"></i>
                        <span>帮助</span>
                    </a>
                </li>


                <li>
                    <a href="lishi.jsp">
                        <i class="icon-bar-chart"></i>
                        <span>历史预览</span>
                    </a>
                </li>


                <li>
                    <a href="">
                        <i class="icon-code"></i>
                        <span>充值</span>
                    </a>
                </li>

                <li class="dropdown">
                    <a href="javascript:;" class="dropdown-toggle" data-toggle="dropdown">
                        <i class="icon-long-arrow-down"></i>
                        <span>历史下载</span>
                        <b class="caret"></b>
                    </a>

                    <ul class="dropdown-menu">
                        <li><a href="">Icons</a></li>
                        <li><a href=".html">FAQ</a></li>
                        <li><a href=".html">Pricing Plans</a></li>
                        <li><a href=".html">Login</a></li>
                        <li><a href=".html">Signup</a></li>
                        <li><a href=".html">404</a></li>
                    </ul>
                </li>

            </ul>

        </div>

    </div>

</div>



<div class="main">

    <div class="main-inner">

        <div class="container">

            <div class="row">

                <div class="span12">

                    <div class="info-box">
                        <div class="row-fluid stats-box">
                            <div class="span4">
                                <div class="stats-box-title">访问人数</div>
                                <div class="stats-box-all-info"><i class="icon-user" style="color:#3366cc;"></i> 555K</div>
                                <div class="wrap-chart"><div id="visitor-stat" class="chart" style="padding: 0px; position: relative;"><canvas id="bar-chart1" class="chart-holder" height="150" width="325"></canvas></div></div>
                            </div>

                            <div class="span4">
                                <div class="stats-box-title">检索满意程度</div>
                                <div class="stats-box-all-info"><i class="icon-thumbs-up"  style="color:#F30"></i> 66.66</div>
                                <div class="wrap-chart"><div id="order-stat" class="chart" style="padding: 0px; position: relative;"><canvas id="bar-chart2" class="chart-holder" height="150" width="325"></canvas></div></div>
                            </div>

                            <div class="span4">
                                <div class="stats-box-title">文献下载总数</div>
                                <div class="stats-box-all-info"><i class="icon-shopping-cart" style="color:#3C3"></i> 15.55</div>
                                <div class="wrap-chart">

                                    <div id="user-stat" class="chart" style="padding: 0px; position: relative;"><canvas id="bar-chart3" class="chart-holder" height="150" width="325"></canvas></div>

                                </div>
                            </div>
                        </div>


                    </div>


                </div>
            </div>

            <!-- /row -->

            <div class="row">

                <div class="span6">

                    <div class="widget">

                        <div class="widget-header">
                            <i class="icon-star"></i>
                            <h3><a href="leixing.jsp">用户访问类型</a></h3>
                        </div> <!-- /widget-header -->

                        <div class="widget-content">
                            <canvas id="pie-chart" class="chart-holder" height="250" width="538"></canvas>
                        </div> <!-- /widget-content -->

                    </div>
                    <div class="widget">
                        <div class="widget-header"> <i class="icon-star"></i>
                            <h3><a href="home.jsp" class="table">内地大陆文献</a></h3>
                        </div>
                        <!-- /widget-header -->
                        <div class="widget-content">
                            <canvas id="pie-chart" class="chart-holder" height="250" width="538"></canvas>
                        </div>
                        <!-- /widget-content -->
                    </div>
                    <p>&nbsp;</p>
                </div>


                <div class="span6">

                    <div class="widget">

                        <div class="widget-header">
                            <i class="icon-list-alt"></i>
                            <h3>文献区域检索比例</h3>
                        </div> <!-- /widget-header -->

                        <div class="widget-content">
                            <canvas id="bar-chart" class="chart-holder" height="250" width="538"></canvas>
                        </div> <!-- /widget-content -->

                    </div>
                    <div class="widget">
                        <div class="widget-header"> <i class="icon-list-alt"></i>
                            <h3>港澳台文献</h3>
                        </div>
                        <!-- /widget-header -->
                        <div class="widget-content">
                            <canvas id="bar-chart" class="chart-holder" height="250" width="1080"></canvas>
                        </div>
                        <!-- /widget-content -->
                    </div>
                    <p>&nbsp;</p>
                    <p>
                        <!-- /widget -->
                    </p>
                </div> <!-- /span6 -->

            </div> <!-- /row -->







        </div> <!-- /container -->

    </div> <!-- /main-inner -->

</div> <!-- /main -->




<div class="extra">

    <div class="extra-inner">

        <div class="container">

            <div class="row">
                <div class="span3">
                    <h4>
                        读者服务</h4>
                    <ul>
                        <li><a href="javascript:;">购买年度文献卡</a></li>
                        <li><a href="javascript:;">充值中心</a></li>
                        <li><a href="javascript:;">我的HWEN</a></li>
                        <li><a href="javascript:;">帮助中心</a></li>
                    </ul>
                </div>
                <!-- /span3 -->
                <div class="span3">
                    <h4>
                        HWEN常用软件下载</h4>
                    <ul>
                        <li><a href="javascript:;">CAJViewer浏览器</a></li>
                        <li><a href="javascript:;">华文研学</a></li>
                        <li><a href="javascript:;">下载中心</a></li>
                        <li><a href="javascript:;">华文词典</a></li>
                    </ul>
                </div>
                <!-- /span3 -->
                <div class="span3">
                    <h4>
                        特色服务</h4>
                    <ul>
                        <li><a href="javascript:;">编创服务</a></li>
                        <li><a href="javascript:;">杂志订阅</a></li>
                        <li><a href="javascript:;">数字出版物订阅</a></li>
                    </ul>
                </div>
                <!-- /span3 -->
                <div class="span3">
                    <h4>
                        客服咨询</h4>
                    <ul>
                        <li><a href="">订卡热线：400-811-9963</a></li>
                        <li><a href="">服务热线：400-811-9868</a></li>
                        <li><a href="">在线咨询：help.HWEN.netn</a></li>
                        <li><a href="">邮件咨询：help@HWEN.net</a></li>
                    </ul>
                </div>
                <!-- /span3 -->
            </div> <!-- /row -->

        </div> <!-- /container -->

    </div> <!-- /extra-inner -->

</div> <!-- /extra -->




<div class="footer">

    <div class="footer-inner">

        <div class="container">

            <div class="row">

                <div class="span12">
                    &copy; 2020 <a href="">教育技术学 要佳欣 杨瑜 联合出品</a></div>
                <!-- /span12 -->

            </div> <!-- /row -->

        </div> <!-- /container -->

    </div> <!-- /footer-inner -->

</div> <!-- /footer -->


<script src="js/jquery-1.7.2.min.js"></script>
<script src="js/excanvas.min.js"></script>
<script src="js/chart.min.js" type="text/javascript"></script>
<script src="js/bootstrap.js"></script>
<script src="js/base.js"></script>
<script>

    var pieData = [
        {
            value: 30,
            color: "#F38630"
        },
        {
            value: 50,
            color: "#E0E4CC"
        },
        {
            value: 100,
            color: "#69D2E7"
        }

    ];

    var myPie = new Chart(document.getElementById("pie-chart").getContext("2d")).Pie(pieData);

    var barChartData = {
        labels: ["January", "February", "March", "April", "May", "June", "July"],
        datasets: [
            {
                fillColor: "rgba(220,220,220,0.5)",
                strokeColor: "rgba(220,220,220,1)",
                data: [65, 59, 90, 81, 56, 55, 40]
            },
            {
                fillColor: "rgba(151,187,205,0.5)",
                strokeColor: "rgba(151,187,205,1)",
                data: [28, 48, 40, 19, 96, 27, 100]
            }
        ]

    }

    var myLine = new Chart(document.getElementById("bar-chart").getContext("2d")).Bar(barChartData);
    var myLine = new Chart(document.getElementById("bar-chart1").getContext("2d")).Bar(barChartData);
    var myLine = new Chart(document.getElementById("bar-chart2").getContext("2d")).Bar(barChartData);
    var myLine = new Chart(document.getElementById("bar-chart3").getContext("2d")).Bar(barChartData);

</script>


</body>

</html>
